Goal of this course is to introduce students to main concepts of relational databases and information systems, as well as to teach students how to create databases and make manipulations with data. The objectives of the course are to acquaint with the advantages and functionality of databases. The task of the course is to give an idea of the concepts of relational databases, as well as to teach students to perform operations in the database - creating a database and tables, inserting, changing, deleting data in a database, making data selection. The aim of the course is to teach students the mathematical foundations of the relational model - functional dependencies and normal forms. Students also need to learn how to build an ER model and create an appropriate database structure. Students learn the components, types and architectures of information systems. Several specific types of information systems are introduced - ERP, CRM, BPM, BI. Students learn about various information systems created by Internet technologies, as well as related problems - security and globalization. Language of instruction is Latvian.
Results
Knowledge
1. Students know concepts of relation data bases. (EB11)
2. Students know concepts of information systems. (EB11, EB12)
3. Students know the main security, legal, and ethical aspects of information systems. (eb41, eb42, eb43, EB44, eb53)
Skills
4. Students have skills to create ER model and data model from informal problem description. (eb21, eb22, EB23,prg26)
5. Students have skills to create database structure according to created data model. (eb24,prg26)
6. Students have skills to create functional dependencies graph for the data model. (eb22, EB23)
7. Students are able to input, delete, update and select data in database. (EB35,adm27)
8. Students are able to create complex SQL commands for data retrieval from multiple tables and with data grouping. (EB35,adm27)
9. Students ar able to use and create simple IS components. (EB12)
Competencies
10. Students can determine database model normal form. (eb22, EB23)
11. Students are able to distinguish different types of information systems and to identify how these information systems are applicable in real world situations. (EB12, eb21, eb25)
